[Template] - Read data from SharePoint

Startup instructions:

How to Connect to SharePoint in KNIME .docx

Tips for node selection:

Required:

• Microsoft Authenticator: Establish authentication

• SharePoint Online Connector: Specify the SharePoint site to connect to

List files/folders in SharePoint

• List files/Folders: View files/folders currently connected

• Table Row to Variable Loop Start & Loop End: Loop through all subfolders

Read/Write a file from SharePoint

• Excel Reader/Writer: Use the standard reader node - Connect it via the SharePoint Online Connector

List files and combine into single file

Combination of Navigation of SharePoint Folder Structure + Read from SharePoint

• Table Row to Variable: Extract the path from the List files/folders output and add this path to the Excel Reader.

How to: List all all files in a SharePoint Folder

List Files/Folders

How to: Read a file from SharePoint & write back a new file

Excel Reader/Writer: Simply connect the standard reader to the SharePoint Online Connector

How to: List all files in a folder and combine into a single file

How to: List all all files and subfolders in a SharePoint folder

Table Row to Variable Loop Start - Loop through all folders.

In each loop -> List the files in that folder and the file name to the final list via (Loop end)